Page 46 - Data_Science_Part_A C12

Formula
A formula is an expression that helps to perform arithmetical calculation and also executes non-arithmetical tasks. It
consists of the operands and operators that operate on the data. Formula has to be expressed with prefix ‘=’ before the
operator/data.

3.4.3 Editing Data in a Cell

There are various methods to edit/change data in a cell:

Method 1
Perform the following steps to edit the data in a cell:
Step 1: Select the cell to be edited by double-clicking it. Then, in the cell or in the Formula Bar, type the additional text.
Step 2: Press the Enter key.

Method 2
Perform the following steps to edit the data in a cell:
Step 1: Click on the cell to be edited.
Step 2: Make any necessary changes to the text in the Formula Bar.

Step 3: Press the Enter key.

Method 3
Perform the following steps if you want to completely change the text in the cell:
Step 1: Click on the cell.
Step 2: Enter the new text.
Step 3: Press the Enter key.

44 Touchpad Data Science-XII